package kr.hkit.powerjava.chapter26;

import java.sql.Connection;
import java.util.Scanner;

import kr.hkit.powerjava.chapter26.common.ConnectionFactory;
import kr.hkit.powerjava.chapter26.common.DbUtil;
import kr.hkit.powerjava.chapter26.dto.Department;
import kr.hkit.powerjava.chapter26.dto.Employee;
import kr.hkit.powerjava.chapter26.service.AbsService;
import kr.hkit.powerjava.chapter26.service.DepartmentService;
import kr.hkit.powerjava.chapter26.service.EmployeeService;



public class TestMain {
	public static void main(String[] args) {
		Scanner sc = new Scanner(System.in);
		Connection connection = ConnectionFactory.getConnection();
		
		System.out.println("1.사원 2.부서 3.종료");
		int res = sc.nextInt();
		if (res == 1){
			AbsService<Employee> empSvc = new EmployeeService(sc, connection);
			empSvc.prnMenu();
		}else if (res==2){
			AbsService<Department> deptSvc = new DepartmentService(sc, connection);
			deptSvc.prnMenu();
		}else{
			DbUtil.close(connection);
		}
		
		
		//Employee가 되도록 지금부터 하세요.....
		
		
		
		

		/*		DepartmentDAO dao = new DepartmentDAO();
		
		try {
			ArrayList<Department> list = dao.listItems();
			for(Department d : list){
				System.out.println(d);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		
		
		Department d = new Department(6, "마케팅", 8);
		try {
			dao.insertItem(d);
			System.out.println("삽입 성공" + d);
		} catch (SQLException e) {
			System.err.println(e.getMessage()+":" + e.getErrorCode());
		}
		
		try {
			d.setDetpName("교육");
			dao.updateItemByNo(d);
			System.out.println("갱신 성공" + d);
		} catch (SQLException e) {
			System.err.println(e.getMessage()+":" + e.getErrorCode());
		}
		
		try {
			dao.deleteItemByNo(new Department(6));
			System.out.println("삭제 성공" + d);
		} catch (SQLException e) {
			e.printStackTrace();
		}*/
		
/*		Connection con = ConnectionFactory.getConnection();
		System.out.println(con);
		String driver = "com.mysql.jdbc.Driver";
		String url = "jdbc:mysql://localhost:3306/mysql_study";
		String user = "root";
		String password = "1111";
		
		DBProperties.savePropertis("dbcon.xml", driver, url, user, password);
		
		
		Properties prop = DBProperties.loadPropertis("dbcon.xml");
		
		DBProperties.prnProperties(prop);*/
		
	}
}
